Profiling Report

Dataset statistics

Number of variables	11
Number of observations	4287
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	368.5 KiB
Average record size in memory	88.0 B

Variable types

Numeric	8
DateTime	2
Text	1

Alerts

`frequency` is highly overall correlated with `last_visit` and 5 other fields	High correlation
`last_visit` is highly overall correlated with `frequency` and 1 other fields	High correlation
`monatary` is highly overall correlated with `frequency` and 4 other fields	High correlation
`recency` is highly overall correlated with `frequency` and 5 other fields	High correlation
`total_items` is highly overall correlated with `frequency` and 4 other fields	High correlation
`total_quantity` is highly overall correlated with `frequency` and 4 other fields	High correlation
`total_unique_items` is highly overall correlated with `frequency` and 4 other fields	High correlation
`monatary` is highly skewed (γ1 = 24.25011359)	Skewed
`total_quantity` is highly skewed (γ1 = 20.24345495)	Skewed
`customer_id` has unique values	Unique

Reproduction

Analysis started	2024-10-01 10:55:14.009198
Analysis finished	2024-10-01 10:55:41.027806
Duration	27.02 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

customer_id
Real number (ℝ)

UNIQUE

Distinct	4287
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15355.474

Minimum	12346
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	12346
5-th percentile	12696.6
Q1	13889.5
median	15361
Q3	16839.5
95-th percentile	17988.7
Maximum	18287
Range	5941
Interquartile range (IQR)	2950

Descriptive statistics

Standard deviation	1700.5656
Coefficient of variation (CV)	0.11074654
Kurtosis	-1.1938072
Mean	15355.474
Median Absolute Deviation (MAD)	1477
Skewness	-0.016714419
Sum	65828915
Variance	2891923.2
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18287	1	< 0.1%
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12351	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
Other values (4277)	4277	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
12346	1	< 0.1%
12347	1	< 0.1%
12348	1	< 0.1%
12349	1	< 0.1%
12351	1	< 0.1%
12352	1	< 0.1%
12353	1	< 0.1%
12355	1	< 0.1%
12356	1	< 0.1%
12357	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18286	1	< 0.1%
18285	1	< 0.1%
18284	1	< 0.1%
18283	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18279	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%

monatary
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	4225
Distinct (%)	98.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2034.552

Minimum	1.55
Maximum	349164.35
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1.55
5-th percentile	111.509
Q1	308.4
median	710.98
Q3	1723.245
95-th percentile	6173.159
Maximum	349164.35
Range	349162.8
Interquartile range (IQR)	1414.845

Descriptive statistics

Standard deviation	8821.9698
Coefficient of variation (CV)	4.3360749
Kurtosis	777.17745
Mean	2034.552
Median Absolute Deviation (MAD)	503.13
Skewness	24.250114
Sum	8722124.4
Variance	77827151
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
102	3	0.1%
165	3	0.1%
131.25	2	< 0.1%
405	2	< 0.1%
79.9	2	< 0.1%
262.4	2	< 0.1%
317.76	2	< 0.1%
209.4	2	< 0.1%
307.95	2	< 0.1%
429	2	< 0.1%
Other values (4215)	4265	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.55	1	< 0.1%
2.95	1	< 0.1%
3.75	1	< 0.1%
6.3	1	< 0.1%
7.49	1	< 0.1%
9.7	1	< 0.1%
10.55	1	< 0.1%
10.95	1	< 0.1%
13.52	1	< 0.1%
13.92	1	< 0.1%

Value	Count	Frequency (%)
349164.35	1	< 0.1%
248396.5	1	< 0.1%
186849	1	< 0.1%
140378.89	1	< 0.1%
131443.19	1	< 0.1%
84541.17	1	< 0.1%
83282.93	1	< 0.1%
80489.21	1	< 0.1%
65500.07	1	< 0.1%
57912.03	1	< 0.1%

frequency
Real number (ℝ)

HIGH CORRELATION

Distinct	63
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.4378353

Minimum	1
Maximum	183
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	5
95-th percentile	13
Maximum	183
Range	182
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	7.9617785
Coefficient of variation (CV)	1.794068
Kurtosis	149.44434
Mean	4.4378353
Median Absolute Deviation (MAD)	1
Skewness	9.8882849
Sum	19025
Variance	63.389917
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1409	32.9%
2	807	18.8%
3	522	12.2%
4	378	8.8%
5	240	5.6%
6	188	4.4%
7	154	3.6%
8	110	2.6%
9	79	1.8%
10	68	1.6%
Other values (53)	332	7.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1409	32.9%
2	807	18.8%
3	522	12.2%
4	378	8.8%
5	240	5.6%
6	188	4.4%
7	154	3.6%
8	110	2.6%
9	79	1.8%
10	68	1.6%

Value	Count	Frequency (%)
183	1	< 0.1%
155	1	< 0.1%
135	1	< 0.1%
120	1	< 0.1%
109	1	< 0.1%
97	1	< 0.1%
94	1	< 0.1%
91	2	< 0.1%
89	1	< 0.1%
86	1	< 0.1%

last_visit
Real number (ℝ)

HIGH CORRELATION

Distinct	300
Distinct (%)	7.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90.63261

Minimum	1
Maximum	374
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	18
median	52
Q3	136
95-th percentile	302.7
Maximum	374
Range	373
Interquartile range (IQR)	118

Descriptive statistics

Standard deviation	96.51785
Coefficient of variation (CV)	1.0649351
Kurtosis	0.64998212
Mean	90.63261
Median Absolute Deviation (MAD)	40
Skewness	1.2950717
Sum	388542
Variance	9315.6954
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	97	2.3%
15	93	2.2%
1	90	2.1%
8	79	1.8%
4	74	1.7%
10	73	1.7%
17	71	1.7%
9	67	1.6%
11	62	1.4%
5	62	1.4%
Other values (290)	3519	82.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	90	2.1%
2	97	2.3%
3	61	1.4%
4	74	1.7%
5	62	1.4%
7	42	1.0%
8	79	1.8%
9	67	1.6%
10	73	1.7%
11	62	1.4%

Value	Count	Frequency (%)
374	7	0.2%
373	9	0.2%
372	8	0.2%
371	6	0.1%
370	1	< 0.1%
369	7	0.2%
368	10	0.2%
367	7	0.2%
366	9	0.2%
365	8	0.2%

recency
Real number (ℝ)

HIGH CORRELATION

Distinct	373
Distinct (%)	8.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	135.34173

Minimum	1
Maximum	374
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	107
Q3	255
95-th percentile	359
Maximum	374
Range	373
Interquartile range (IQR)	254

Descriptive statistics

Standard deviation	132.76003
Coefficient of variation (CV)	0.98092461
Kurtosis	-1.3514863
Mean	135.34173
Median Absolute Deviation (MAD)	106
Skewness	0.41450077
Sum	580210
Variance	17625.227
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	1478	34.5%
358	26	0.6%
370	22	0.5%
357	21	0.5%
363	21	0.5%
360	20	0.5%
361	19	0.4%
350	19	0.4%
359	19	0.4%
355	19	0.4%
Other values (363)	2623	61.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1478	34.5%
2	5	0.1%
3	7	0.2%
4	4	0.1%
5	5	0.1%
6	7	0.2%
7	11	0.3%
8	2	< 0.1%
9	2	< 0.1%
10	9	0.2%

Value	Count	Frequency (%)
374	5	0.1%
373	10	0.2%
372	14	0.3%
371	12	0.3%
370	22	0.5%
369	14	0.3%
368	7	0.2%
367	15	0.3%
366	11	0.3%
365	12	0.3%

total_quantity
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	1757
Distinct (%)	41.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1291.1787

Minimum	1
Maximum	220600
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1
5-th percentile	46
Q1	162
median	386
Q3	1001
95-th percentile	3440.5
Maximum	220600
Range	220599
Interquartile range (IQR)	839

Descriptive statistics

Standard deviation	6476.3168
Coefficient of variation (CV)	5.0158176
Kurtosis	520.83429
Mean	1291.1787
Median Absolute Deviation (MAD)	286
Skewness	20.243455
Sum	5535283
Variance	41942679
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60	19	0.4%
72	18	0.4%
48	17	0.4%
96	17	0.4%
108	16	0.4%
74	15	0.3%
144	15	0.3%
100	14	0.3%
24	14	0.3%
138	13	0.3%
Other values (1747)	4129	96.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	9	0.2%
2	3	0.1%
3	5	0.1%
4	2	< 0.1%
5	5	0.1%
6	5	0.1%
7	1	< 0.1%
8	2	< 0.1%
10	4	0.1%
11	3	0.1%

Value	Count	Frequency (%)
220600	1	< 0.1%
170278	1	< 0.1%
125893	1	< 0.1%
124216	1	< 0.1%
108076	1	< 0.1%
87829	1	< 0.1%
87167	1	< 0.1%
75824	1	< 0.1%
69637	1	< 0.1%
63551	1	< 0.1%

total_unique_items
Real number (ℝ)

HIGH CORRELATION

Distinct	346
Distinct (%)	8.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.930488

Minimum	1
Maximum	1737
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	17
median	38
Q3	80
95-th percentile	203
Maximum	1737
Range	1736
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	85.757359
Coefficient of variation (CV)	1.3414157
Kurtosis	78.30722
Mean	63.930488
Median Absolute Deviation (MAD)	26
Skewness	6.1435101
Sum	274070
Variance	7354.3246
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	89	2.1%
23	80	1.9%
13	78	1.8%
16	77	1.8%
11	75	1.7%
19	68	1.6%
14	68	1.6%
8	66	1.5%
6	66	1.5%
7	65	1.5%
Other values (336)	3555	82.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	89	2.1%
2	55	1.3%
3	45	1.0%
4	61	1.4%
5	63	1.5%
6	66	1.5%
7	65	1.5%
8	66	1.5%
9	62	1.4%
10	56	1.3%

Value	Count	Frequency (%)
1737	1	< 0.1%
1507	1	< 0.1%
1339	1	< 0.1%
1091	1	< 0.1%
1084	1	< 0.1%
712	1	< 0.1%
654	1	< 0.1%
646	1	< 0.1%
606	1	< 0.1%
593	1	< 0.1%

total_items
Real number (ℝ)

HIGH CORRELATION

Distinct	471
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	94.945883

Minimum	1
Maximum	5485
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	33.6 KiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	18.5
median	44
Q3	103
95-th percentile	323.7
Maximum	5485
Range	5484
Interquartile range (IQR)	84.5

Descriptive statistics

Standard deviation	201.6959
Coefficient of variation (CV)	2.1243248
Kurtosis	257.87163
Mean	94.945883
Median Absolute Deviation (MAD)	32
Skewness	12.625668
Sum	407033
Variance	40681.235
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13	78	1.8%
1	75	1.7%
12	66	1.5%
6	65	1.5%
11	63	1.5%
9	63	1.5%
16	63	1.5%
18	62	1.4%
23	60	1.4%
21	60	1.4%
Other values (461)	3632	84.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	75	1.7%
2	49	1.1%
3	38	0.9%
4	56	1.3%
5	56	1.3%
6	65	1.5%
7	60	1.4%
8	59	1.4%
9	63	1.5%
10	52	1.2%

Value	Count	Frequency (%)
5485	1	< 0.1%
5041	1	< 0.1%
3857	1	< 0.1%
2617	1	< 0.1%
2615	1	< 0.1%
2499	1	< 0.1%
2269	1	< 0.1%
2052	1	< 0.1%
1773	1	< 0.1%
1726	1	< 0.1%

last_purchase
Date

Distinct	4162
Distinct (%)	97.1%
Missing	0
Missing (%)	0.0%
Memory size	33.6 KiB

Minimum	2009-12-01 09:55:00
Maximum	2010-12-09 20:01:00

Histogram

Histogram with fixed size bins (bins=50)

first_purchase
Date

Distinct	4190
Distinct (%)	97.7%
Missing	0
Missing (%)	0.0%
Memory size	33.6 KiB

Minimum	2009-12-01 07:45:00
Maximum	2010-12-09 16:08:00

Histogram

Histogram with fixed size bins (bins=50)

most_purchase_item
Text

Distinct	1118
Distinct (%)	26.1%
Missing	0
Missing (%)	0.0%
Memory size	33.6 KiB

Length

Max length	7
Median length	5
Mean length	5.1182645
Min length	4

Characters and Unicode

Total characters	21942
Distinct characters	29
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	533 ?
Unique (%)	12.4%

Sample

1st row	15056BL
2nd row	84558A
3rd row	21211
4th row	16156S
5th row	20886

Value	Count	Frequency (%)
85123a	121	2.8%
21034	76	1.8%
20914	64	1.5%
21232	62	1.4%
post	61	1.4%
20725	59	1.4%
20685	58	1.4%
21754	47	1.1%
15036	39	0.9%
22423	36	0.8%
Other values (1108)	3664	85.5%

Most occurring characters

Value	Count	Frequency (%)
2	5314	24.2%
1	3605	16.4%
0	2254	10.3%
7	1653	7.5%
5	1591	7.3%
8	1523	6.9%
4	1365	6.2%
6	1315	6.0%
3	1277	5.8%
9	1233	5.6%
Other values (19)	812	3.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	21942	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
2	5314	24.2%
1	3605	16.4%
0	2254	10.3%
7	1653	7.5%
5	1591	7.3%
8	1523	6.9%
4	1365	6.2%
6	1315	6.0%
3	1277	5.8%
9	1233	5.6%
Other values (19)	812	3.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	21942	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
2	5314	24.2%
1	3605	16.4%
0	2254	10.3%
7	1653	7.5%
5	1591	7.3%
8	1523	6.9%
4	1365	6.2%
6	1315	6.0%
3	1277	5.8%
9	1233	5.6%
Other values (19)	812	3.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	21942	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
2	5314	24.2%
1	3605	16.4%
0	2254	10.3%
7	1653	7.5%
5	1591	7.3%
8	1523	6.9%
4	1365	6.2%
6	1315	6.0%
3	1277	5.8%
9	1233	5.6%
Other values (19)	812	3.7%

Auto

Heatmap
Table

	customer_id	frequency	last_visit	monatary	recency	total_items	total_quantity	total_unique_items
customer_id	1.000	-0.002	-0.017	-0.084	-0.009	0.001	-0.068	0.001
frequency	-0.002	1.000	-0.526	0.828	0.887	0.744	0.775	0.672
last_visit	-0.017	-0.526	1.000	-0.461	-0.538	-0.469	-0.433	-0.431
monatary	-0.084	0.828	-0.461	1.000	0.740	0.794	0.938	0.744
recency	-0.009	0.887	-0.538	0.740	1.000	0.664	0.689	0.606
total_items	0.001	0.744	-0.469	0.794	0.664	1.000	0.768	0.985
total_quantity	-0.068	0.775	-0.433	0.938	0.689	0.768	1.000	0.723
total_unique_items	0.001	0.672	-0.431	0.744	0.606	0.985	0.723	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	monatary	frequency	last_visit	recency	total_quantity	total_unique_items	total_items	last_purchase	first_purchase	most_purchase_item
0	12346.00	169.36	2	165	119	24	24	24	2010-06-28 13:53:00	2010-03-02 13:08:00	15056BL
1	12347.00	1323.32	2	3	38	828	70	71	2010-12-07 14:57:00	2010-10-31 14:20:00	84558A
2	12348.00	222.16	1	74	1	373	20	20	2010-09-27 14:59:00	2010-09-27 14:59:00	21211
3	12349.00	2671.14	3	43	182	993	90	102	2010-10-28 08:23:00	2010-04-29 13:20:00	16156S
4	12351.00	300.93	1	11	1	261	21	21	2010-11-29 15:23:00	2010-11-29 15:23:00	20886
5	12352.00	343.80	2	11	17	188	18	18	2010-11-29 10:07:00	2010-11-12 10:20:00	21121
6	12353.00	317.76	1	44	1	192	20	20	2010-10-27 12:44:00	2010-10-27 12:44:00	20617
7	12355.00	488.21	1	203	1	303	22	22	2010-05-21 11:59:00	2010-05-21 11:59:00	20818
8	12356.00	3562.25	3	16	45	1826	68	84	2010-11-24 12:24:00	2010-10-11 09:42:00	16156S
9	12357.00	12079.99	2	24	1	3879	165	165	2010-11-16 14:29:00	2010-11-16 10:05:00	10002

	customer_id	monatary	frequency	last_visit	recency	total_quantity	total_unique_items	total_items	last_purchase	first_purchase	most_purchase_item
4277	18277.00	1069.67	4	33	98	381	48	56	2010-11-07 15:52:00	2010-08-02 10:26:00	15056BL
4278	18278.00	240.30	1	40	1	74	15	15	2010-10-31 12:13:00	2010-10-31 12:13:00	20914
4279	18279.00	231.34	1	155	1	630	13	13	2010-07-08 14:48:00	2010-07-08 14:48:00	17003
4280	18280.00	307.55	1	30	1	149	20	20	2010-11-10 15:51:00	2010-11-10 15:51:00	21114
4281	18281.00	120.32	1	213	1	92	10	10	2010-05-11 10:49:00	2010-05-11 10:49:00	20719
4282	18283.00	641.77	6	18	276	336	158	230	2010-11-22 15:30:00	2010-02-19 17:16:00	20727
4283	18284.00	411.68	1	67	1	493	27	27	2010-10-04 11:33:00	2010-10-04 11:33:00	16237
4284	18285.00	377.00	1	296	1	144	11	11	2010-02-17 10:24:00	2010-02-17 10:24:00	20802
4285	18286.00	1246.43	2	112	248	607	66	66	2010-08-20 11:57:00	2009-12-16 10:45:00	10135
4286	18287.00	2295.71	4	18	189	1426	76	84	2010-11-22 11:51:00	2010-05-17 11:55:00	22064

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Interactions

Correlations

Missing values

Sample